﻿CREATE TABLE [dbo].[Reteta] (
    [idCons]       INT           NOT NULL,
    [idMedicament] INT           NOT NULL,
    [Observatii]   VARCHAR (200) NULL,
    CONSTRAINT [PK_Reteta] PRIMARY KEY CLUSTERED ([idCons] ASC, [idMedicament] ASC),
    CONSTRAINT [FK_Reteta_Medicamente] FOREIGN KEY ([idMedicament]) REFERENCES [dbo].[Medicamente] ([idMedicament])
);

